﻿IF object_id(N'dbo.UDS_Team', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Team] (
        [Team_ID]          int          NOT NULL identity(1, 1),
        [Super_Team_ID]    int          NULL,
        [Team_Name]        nvarchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
        [Team_Description] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,

        CONSTRAINT [PK_UDS_Team] PRIMARY KEY CLUSTERED ([Team_ID] asc),
        CONSTRAINT [FK_UDS_Team_UDS_Team] FOREIGN KEY ([Super_Team_ID]) REFERENCES [dbo].[UDS_Team] ([Team_ID])
    );
END
GO
